<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10" viewPagesAsTabs="topLeft"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-19. 15:48:25--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;quot; to &amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;quot; at 2015-4-14. 11:21:48-->
                <modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
                <drillBehavior/>
                
                <layouts>
                    <layout>
                        <reportPages>
                            <page name="Overview"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1024px"/></style>
                                <pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles><CSS value="background-color:white"/></style>
                                    <contents>
                                        
                                    <HTMLItem>
            <dataSource>
                <staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
            </dataSource>
        </HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Storage Infrastructure Executive Summary</staticValue></dataSource><style><CSS value="color:#454545;font-family:Arial;font-size:24px"/></style></textItem></contents><style><CSS value="background-color:#FBFBFB;color:#454545;width:100%;height:36px;padding-left:24px;border-bottom:1px solid #E2E2E1"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-bottom:5px"/></style></textItem><singleton name="Singleton27" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable Change (Hidden)"/></dataSource><style><CSS value="display:none;font-family:Arial;font-size:14px;color:#656565"/></style></textItem></contents>
        </singleton></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Usable (TB) is Post-RAID capacity allocated to the storage pool and available for use"</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton5" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;color:#808080;font-weight:bold"/><dataFormat><numberFormat pattern="###,###,###.## TB"/></dataFormat></style></textItem></contents>
        </singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton35" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable Changes"/></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-left:10px"/></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 7"/></conditionalStyleRefs></textItem></contents>
        </singleton><singleton name="Singleton36" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable Percentage"/></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-left:10px"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 7"/></conditionalStyleRefs></textItem></contents>
        </singleton></contents><style><CSS value="text-align:center;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Allocated Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-bottom:5px"/></style></textItem><singleton name="Singleton28" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Changes (Hidden)"/></dataSource><style><CSS value="display:none;font-family:Arial;font-size:14px;color:#656565"/></style></textItem></contents>
        </singleton></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style="cursor:help" "color:black" title="Allocated (TB) is capacity provisioned to hosts"</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton6" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;color:#808080;font-weight:bold"/><dataFormat><numberFormat pattern="###,###,###.## TB"/></dataFormat></style></textItem></contents>
        </singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton30" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Changes"/></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-left:10px"/></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 8"/></conditionalStyleRefs></textItem></contents>
        </singleton><singleton name="Singleton29" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Percentage"/></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-left:10px"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 8"/></conditionalStyleRefs></textItem></contents>
        </singleton></contents><style><CSS value="text-align:center;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Available Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-bottom:5px"/></style></textItem><singleton name="Singleton31" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Changes (Hidden)"/></dataSource><style><CSS value="display:none"/></style></textItem></contents>
        </singleton></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style="cursor:help" "color:black" title="Available (TB) is capacity in the storage pool that has NOT BEEN provisioned to hosts"</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton7" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Available (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:24pt;color:#808080"/><dataFormat><numberFormat pattern="###,###,###.## TB"/></dataFormat></style></textItem></contents>
        </singleton><HTMLItem>
			<dataSource>
				<staticValue/>
			</dataSource>
		</HTMLItem><singleton name="Singleton32" refQuery="Global Capacity Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Available Changes"/></dataSource><style><CSS value="font-family:Arial;font-size:14px;color:#656565;padding-left:10px"/></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 8"/></conditionalStyleRefs></textItem></contents>
        </singleton><singleton name="Singleton33" refQuery="Global Capacity Changes">
            <contents/>
        </singleton></contents><style><CSS value="text-align:center;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Annual Growth</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Capacity in (TB))</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Capacity (TB) is Post-RAID capacity allocated to the storage pool and available for use.     Used Capacity (TB) is either capacity that is allocated (if THICK provisioned) or capacity that is written (if THIN provisioned)."</staticValue>
			</dataSource>
		</HTMLItem><v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart12" refQuery="Base Capacity Long Term Trend">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar barShape="box" borderColor="white">
																							<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;quot;/ -->
																							<v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																					</v2_combinationChartTypes>
																					<v2_axis>
																						
																						<v2_axisRange>
																							<v2_automaticRange/>
																						</v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<CSS value="width:450px;height:315px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<chartSuppress type="categories"/><v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Used vs Free</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Capacity in (TB))</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
					<v2_pieChart bevel="round" depth="0" maxHotspots="10000" name="Combination Chart11" refQuery="Base Capacity" sliceStartAngle="90">
														<v2_pieTooltips/>
														
														
														<style>
															<CSS value="width:375px;height:275px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<v2_pieSlices borderColor="white" borders="show">
															<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
															<v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Free Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
														<chartSuppress type="categories"/><XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_pieChart><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;margin-top:5px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:15px;height:10px;background-color:#88B2D3"/></style></block></contents><style><CSS value="padding-right:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Used (TB): </staticValue></dataSource><style><CSS value="color:gray;font-weight:bold;font-style:italic"/></style></textItem></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><singleton name="Singleton19" refQuery="Base Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Capacity (TB)"/></dataSource><style><CSS value="font-style:italic;font-weight:bold;color:gray"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px;text-align:right"/></style></tableCell><tableCell><contents/><style><CSS value="text-align:right;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents/><style><CSS value="text-align:center;padding-top:5px;padding-bottom:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:15px;height:10px;background-color:#B8B8BF"/></style></block></contents><style><CSS value="padding-right:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Free (TB):</staticValue></dataSource><style><CSS value="color:gray;font-weight:bold;font-style:italic"/></style></textItem></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents><singleton name="Singleton20" refQuery="Base Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Free Capacity (TB)"/></dataSource><style><CSS value="color:gray;font-weight:bold;font-style:italic"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px;text-align:right;vertical-align:top"/></style></tableCell><tableCell><contents/><style><CSS value="text-align:right;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-bottom:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Used Trending</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Capacity in (TB))</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Used (TB) is either capacity that is allocated (if THICK provisioned) or capacity that is written (if THIN provisioned)."</staticValue>
			</dataSource>
		</HTMLItem><v2_combinationChart maxHotspots="10000" name="Combination Chart2" refQuery="Capacity Trending">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					<v2_labelControl displayFrequency="2"/></v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:450px;height:315px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Savings</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(from Storage Efficiency Technologies)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:7px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents>
																								<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:300px;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Capacity Savings (TB)</staticValue></dataSource><style><CSS value="font-size:16pt"/></style></textItem></contents><style><CSS value="font-size:22pt;color:gray;font-weight:bold;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Thin Savings (TB) is Over-Subscribed Capacity e.g. capacity that is over 100% allocated derived from (Allocated / Usable) - 100 *  Usable.  This gives us the amount of capacity we would have to purchase if NOT using thin provisioning technology." 
</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton10" refQuery="Storage Efficency Savings">
			<contents><textItem><dataSource><dataItemValue refDataItem="Thin Savings (TB)"/></dataSource><style><CSS value="font-size:26pt;color:#99CC99;font-weight:bold"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Capacity Cost Savings</staticValue></dataSource><style><CSS value="font-size:14pt;color:gray;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:10px;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Thin Cost Savings is the actual dollar amount, derived from the COST annotation configured in OCI * Thin Savings (TB).  This shows the amount of money you are saving by using Thin Provisioning technology."</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton11" refQuery="Storage Efficency Savings">
			<contents><textItem><dataSource><dataItemValue refDataItem="Thin Cost Savings"/></dataSource><style><CSS value="font-size:26pt;color:#FAD996;font-weight:bold"/><dataFormat><numberFormat pattern="'$'###,###"/></dataFormat></style></textItem></contents>
		</singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:300px;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Dedupe Savings (TB)</staticValue></dataSource><style><CSS value="font-size:16pt"/></style></textItem></contents><style><CSS value="font-size:22pt;color:gray;font-weight:bold;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Dedupe Savings (TB) is NetApp Flexvol Used Capacity * (1 minus the NetApp Flexvol dedupeRatio) divided by the NetApp Flexvol dedupeRatio).  This shows the amount of capacity you would have to purchase IF NOT using Deduplication technology." 
</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton21" refQuery="Storage Efficency Savings">
			<contents><textItem><dataSource><dataItemValue refDataItem="Dedupe Savings (TB)"/></dataSource><style><CSS value="font-size:26pt;color:#99CC99;font-weight:bold"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Dedupe Cost Savings</staticValue></dataSource><style><CSS value="font-size:14pt;color:gray;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:10px;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Dedupe Cost Savings is the actual dollar amount, derived from the COST annotation configured in OCI * Dedupe Savings (TB).  This shows the amount of money you are saving by using  Deduplication technology."</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton22" refQuery="Storage Efficency Savings">
			<contents><textItem><dataSource><dataItemValue refDataItem="Dedupe Cost Savings"/></dataSource><style><CSS value="font-size:26pt;color:#FAD996;font-weight:bold"/><dataFormat><numberFormat pattern="'$'###,###"/></dataFormat></style></textItem></contents>
		</singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-right:10px;padding-left:10px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:300px;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Compression Savings (TB)</staticValue></dataSource><style><CSS value="font-size:16pt"/></style></textItem></contents><style><CSS value="font-size:22pt;color:gray;font-weight:bold;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Compression Savings (TB) is NetApp Flexvol Used Capacity * (1 minus the NetApp Flexvol compressionRatio) divided by the NetApp Flexvol compressionRatio).  This shows the amount of capacity you would have to purchase IF NOT using Compression technology." 
</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton23" refQuery="Storage Efficency Savings">
			<contents><textItem><dataSource><dataItemValue refDataItem="Comp Savings (TB)"/></dataSource><style><CSS value="font-size:26pt;color:#99CC99;font-weight:bold"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Compression Cost Savings</staticValue></dataSource><style><CSS value="font-size:14pt;color:gray;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:10px;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Compression Cost Savings is the actual dollar amount, derived from the COST annotation configured in OCI * Compression Savings (TB).  This shows the amount of money you are saving by using Compression technology."</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton24" refQuery="Storage Efficency Savings">
			<contents><textItem><dataSource><dataItemValue refDataItem="Comp Cost Savings"/></dataSource><style><CSS value="font-size:26pt;color:#FAD996;font-weight:bold"/><dataFormat><numberFormat pattern="'$'###,###"/></dataFormat></style></textItem></contents>
		</singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-bottom:10px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;text-align:center;padding-bottom:10px;padding-top:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Costs</staticValue></dataSource><style><CSS value="color:#656565;padding-bottom:5px"/></style></textItem><singleton name="Singleton58" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable Change (Hidden)"/></dataSource><style><CSS value="display:none;color:#656565"/></style></textItem></contents>
        </singleton></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Usable Costs is the actual cost of the Usable Capacity, derived from the COST annotation configured in OCI * Usable Capacity (TB)."</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton14" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable Costs"/></dataSource><style><CSS value="font-family:Arial;font-size:20px;color:#808080"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style></textItem></contents>
        </singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton59" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable Changes"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#333333;padding-left:10px;font-weight:normal"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 9"/></conditionalStyleRefs></textItem></contents>
        </singleton><singleton name="Singleton60" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Usable Percentage"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#333333;padding-left:10px;font-weight:normal"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 9"/></conditionalStyleRefs></textItem></contents>
        </singleton></contents><style><CSS value="text-align:center;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:250px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Costs</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:#656565;padding-bottom:5px"/></style></textItem><singleton name="Singleton8" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Used Change (Hidden)"/></dataSource><style><CSS value="display:none;color:#656565"/></style></textItem></contents>
        </singleton></contents><style><CSS value="padding-top:5px;padding-left:5px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Used Costs is the actual cost of the Used Capacity, derived from the COST annotation configured in OCI * Used Capacity (TB)."</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton15" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Used Costs"/></dataSource><style><CSS value="font-family:Arial;font-size:20px;color:#808080"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style></textItem></contents>
        </singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton52" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Used Changes"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#333333;padding-left:10px;font-weight:normal"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 10"/></conditionalStyleRefs></textItem></contents>
        </singleton><singleton name="Singleton61" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Used Percentage"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#333333;padding-left:10px;font-weight:normal"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 10"/></conditionalStyleRefs></textItem></contents>
        </singleton></contents><style><CSS value="text-align:center;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:250px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Allocated Costs</staticValue></dataSource><style><CSS value="color:#656565;padding-bottom:5px"/></style></textItem><singleton name="Singleton9" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Changes (Hidden)"/></dataSource><style><CSS value="display:none;color:#656565"/></style></textItem></contents>
        </singleton></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Allocated Costs is the actual cost of all Thick and Thin Allocated Capacity, derived from the COST annotation configured in OCI * Allocated (TB)."</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton16" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Costs"/></dataSource><style><CSS value="font-family:Arial;font-size:20px;color:#808080"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style></textItem></contents>
        </singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton49" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Changes"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#333333;padding-left:10px;font-weight:normal"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 11"/></conditionalStyleRefs></textItem></contents>
        </singleton><singleton name="Singleton62" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Allocated Percentage"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#333333;padding-left:10px;font-weight:normal"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 11"/></conditionalStyleRefs></textItem></contents>
        </singleton></contents><style><CSS value="text-align:center;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:250px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Free Costs</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold;color:#656565;padding-bottom:5px"/></style></textItem><singleton name="Singleton17" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Free Change (Hidden)"/></dataSource><style><CSS value="display:none;color:#656565"/></style></textItem></contents>
        </singleton></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Free Costs is the actual cost of all Free (Available) Capacity, derived from the COST annotation configured in OCI * Free (TB)."</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton18" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Free Costs"/></dataSource><style><CSS value="font-family:Arial;font-size:20px;color:#808080"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style></textItem></contents>
        </singleton><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem><singleton name="Singleton63" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Free Changes"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#808080;padding-left:10px;font-weight:normal"/><dataFormat><currencyFormat pattern="$###,###,###.##M"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 12"/></conditionalStyleRefs></textItem></contents>
        </singleton><singleton name="Singleton64" refQuery="Global Cost Changes">
            <contents><textItem><dataSource><dataItemValue refDataItem="Free Percentage"/></dataSource><style><CSS value="font-family:Arial;font-size:16px;color:#808080;padding-left:10px;font-weight:normal"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 12"/></conditionalStyleRefs></textItem></contents>
        </singleton></contents><style><CSS value="text-align:center;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="width:250px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;height:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents/><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
                                </pageBody>
                                
                                <pageFooter>
                                    <contents>
                                        
                                    <table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
                                    <style>
                                        <defaultStyles>
                                            <defaultStyle refStyle="pf"/>
                                        </defaultStyles>
                                        <CSS value="padding:10px 15px 10px 15px;background-color:#FBFBFB;border-top:1px solid #E1E1E2"/>
                                    </style>
                                </pageFooter>
                            <pageSetup orientation="portrait"><customPaper width="12" height="11" unit="in"/></pageSetup></page>
                        <page name="Utilization">
			<pageBody>
				<contents><HTMLItem>
            <dataSource>
                <staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
            </dataSource>
        </HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Storage Infrastructure Executive Summary</staticValue></dataSource><style><CSS value="color:#454545;font-family:Arial;font-size:24px"/></style></textItem></contents><style><CSS value="background-color:#FBFBFB;color:#454545;width:100%;height:36px;padding-left:24px;border-bottom:1px solid #E2E2E1"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell colSpan="4"><contents><textItem><dataSource><staticValue>Current Workload Utilization</staticValue></dataSource><style><CSS value="font-size:12pt;color:white;font-weight:bold"/></style></textItem></contents><style><CSS value="background-color:#6198C5;padding-top:2px;padding-bottom:2px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents><textItem><dataSource><staticValue>NetApp</staticValue></dataSource><style><CSS value="font-size:22pt;color:gray;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-bottom:5px;padding-left:20px"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents><list horizontalPagination="true" name="List1" refQuery="Head Room Query - Release 4" rowsPerPage="100">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-size:14pt"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-size:14pt;color:#323232;text-align:left;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Storage Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-size:14pt"/></style><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="The Peak Node CPU Utilization % derived from CPU, Kahuna Domain and WAFL metrics and collected over a period of 14 days HOURLY"</staticValue>
			</dataSource>
		</HTMLItem><textItem><dataSource><dataItemLabel refDataItem="Peak CPU Utilization"/></dataSource></textItem><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat pattern="###'%'"/></dataFormat><CSS value="font-size:14pt;color:#323232;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak CPU Utilization"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 2"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-size:14pt"/></style><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Current Workload % is the Read and Write Peak IOpS divided by the IOpS Capability.  IOpS Capability is the theoretical IOpS limit as published by the disk manufacturer for  each disk that support the aggregate.  For instance, a SAS 15K disk will provide an average of up to 200 IOpS depending on the type of IO activity."</staticValue>
			</dataSource>
		</HTMLItem><textItem><dataSource><dataItemLabel refDataItem="Current Workload %"/></dataSource></textItem><HTMLItem>
			<dataSource>
				<staticValue/>
			</dataSource>
		</HTMLItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat><CSS value="font-size:14pt;color:#323232;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Current Workload %"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 3"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-size:14pt"/></style><contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;span style= "cursor:help" "color:black;" title="Capacity Utilization % is derived from Used Capacity divided by Usable Capacity."</staticValue>
			</dataSource>
		</HTMLItem><textItem><dataSource><dataItemLabel refDataItem="Capacity Utilization %"/></dataSource></textItem><HTMLItem>
			<dataSource>
				<staticValue>&lt;/span&gt;</staticValue>
			</dataSource>
		</HTMLItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat><CSS value="font-size:14pt;color:#323232;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity Utilization %"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 4"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-size:14pt"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-size:16pt;color:#323232;text-align:right;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Status"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Storage Name"/></listGroups></list></contents><style><CSS value="font-size:24pt;font-weight:bold;color:gray;padding-right:75px"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="padding-top:25px;padding-left:15px;vertical-align:top"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="padding-top:25px;padding-left:15px;vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="pb"/>
					</defaultStyles>
				</style>
			</pageBody>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pg"/>
				</defaultStyles>
			</style>
		<pageSetup orientation="portrait"><customPaper width="19" height="15" unit="in"/></pageSetup></page><page name="Definitions">
			<pageBody>
				<contents><HTMLItem>
            <dataSource>
                <staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
            </dataSource>
        </HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Storage Infrastructure Executive Summary</staticValue></dataSource><style><CSS value="color:#454545;font-family:Arial;font-size:24px"/></style></textItem></contents><style><CSS value="background-color:#FBFBFB;color:#454545;width:100%;height:36px;padding-left:24px;border-bottom:1px solid #E2E2E1"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell colSpan="4"><contents><textItem><dataSource><staticValue>Overview - Definitions</staticValue></dataSource><style><CSS value="font-size:12pt;color:white;font-weight:bold"/></style></textItem></contents><style><CSS value="background-color:#6198C5;padding-top:2px;padding-bottom:2px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="4"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Post-RAID capacity allocated to the storage pool and available for use</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Allocated Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity provisioned to hosts</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Available Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity (TB) - Total Allocated Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Same as Total Usable Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Used Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Used Capacity (TB) is either capacity that is allocated (if THICK provisioned) or capacity that is written (if THIN provisioned)</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Used (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Same as Used Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Free (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity (TB) - Used Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue> </staticValue></dataSource></textItem></contents><style><CSS value="padding-top:3px;padding-bottom:3px;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents/><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Capacity Savings (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Thin Savings (TB) is Over-Subscribed Capacity e.g. capacity that is over 100% allocated derived from (Allocated / Usable) - 100 *  Usable.  This gives us the amount of capacity we would have to purchase if NOT using thin provisioning technology.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Dedupe Savings (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Dedupe Savings (TB) is NetApp Flexvol Used Capacity * (1 minus the NetApp Flexvol dedupeRatio) divided by the NetApp Flexvol dedupeRatio).  This shows the amount of capacity you would have to purchase IF NOT using Deduplication technology.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Compression Savings (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Compression Savings (TB) is NetApp Flexvol Used Capacity * (1 minus the NetApp Flexvol compressionRatio) divided by the NetApp Flexvol compressionRatio).  This shows the amount of capacity you would have to purchase IF NOT using Compression technology.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Capacity Cost Savings</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Thin Cost Savings is the actual dollar amount, derived from the COST annotation configured in OCI * Thin Savings (TB).  This shows the amount of money you are saving by using Thin Provisioning technology.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Dedupe Cost Savings</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Dedupe Cost Savings is the actual dollar amount, derived from the COST annotation configured in OCI * Dedupe Savings (TB).  This shows the amount of money you are saving by using  Deduplication technology.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Compression Cost Savings</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Compression Cost Savings is the actual dollar amount, derived from the COST annotation configured in OCI * Compression Savings (TB).  This shows the amount of money you are saving by using Compression technology.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue> </staticValue></dataSource></textItem></contents><style><CSS value="padding-top:3px;padding-bottom:3px;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents/><style><CSS value="width:700px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Costs</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Usable Costs is the actual cost of the Usable Capacity, derived from the COST annotation configured in OCI * Usable Capacity (TB).</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Costs</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Used Costs is the actual cost of the Used Capacity, derived from the COST annotation configured in OCI * Used Capacity (TB).</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Allocated Costs</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Allocated Costs is the actual cost of all Thick and Thin Allocated Capacity, derived from the COST annotation configured in OCI * Allocated (TB).</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Free Costs</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Free Costs is the actual cost of all Free Capacity, derived from the COST annotation configured in OCI * Free (TB).</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;padding-bottom:5px;padding-left:20px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-top:15px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell colSpan="4"><contents><textItem><dataSource><staticValue>Workload Trend - Definitions</staticValue></dataSource><style><CSS value="font-size:12pt;color:white;font-weight:bold"/></style></textItem></contents><style><CSS value="background-color:#6198C5;padding-top:2px;padding-bottom:2px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="4"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>TotalUsableTB</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Post-RAID capacity allocated to the storage pool and available for use</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>TotalUsedTB</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Used Capacity (TB) is either capacity that is allocated (if THICK provisioned) or capacity that is written (if THIN provisioned)</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Provisioned (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>SAN capacity provisioned to host initiators (EMC specific)</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Volume Consumed Capacity (TB)</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Shows Volume Written Capacity if Thin Provisioned.  Will equal Provisioned (TB) if Thick.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;padding-bottom:5px;padding-left:20px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:15px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell colSpan="4"><contents><textItem><dataSource><staticValue>Utilization - Definitions</staticValue></dataSource><style><CSS value="font-size:12pt;color:white;font-weight:bold"/></style></textItem></contents><style><CSS value="background-color:#6198C5;padding-top:2px;padding-bottom:2px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="4"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Node Name</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Name of the NetApp Node associated with the Cluster or HA Pair</staticValue></dataSource></textItem></contents><style><CSS value="color:#323232"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Peak Node Utilization %</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>The Peak Node CPU Utilization % derived from CPU, Kahuna Domain and WAFL metrics and collected over a period of 14 days HOURLY</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Current Workload %</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Current Workload % is the Read and Write Peak IOpS divided by the IOpS Capability.  IOpS Capability is the theoretical IOpS limit as published by the disk manufacturer for  each disk that support the aggregate.  For instance, a SAS 15K disk will provide an average of up to 200 IOpS depending on the type of IO activity.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity Utilization %</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Utilization % is derived from Used Capacity divided by Usable Capacity.</staticValue></dataSource></textItem></contents><style><CSS value="width:700px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Status</staticValue></dataSource></textItem></contents><style><CSS value="padding:3px 25px 3px 10px;color:#323232;width:200px;border:1pt solid silver"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>OK</staticValue></dataSource></textItem></contents><style><CSS value="padding-right:25px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>WHEN Peak CPU Utilization &lt; 50% AND Current Workload % &lt; 50% AND Capacity Utilization % &lt; 75% then the controller status is OK </staticValue></dataSource></textItem></contents><style><CSS value="padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>WARNING - Head Room at Risk</staticValue></dataSource></textItem></contents><style><CSS value="padding-right:25px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>WHEN Sustained Peak CPU Utilization &gt;= 50% for 14 Days Hourly</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>WARNING - Heavy Workload Activity Approaching Maximum Capability </staticValue></dataSource></textItem></contents><style><CSS value="padding-right:25px;padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>WHEN Sustained Current Workload % &gt;= 50% for 14 Days Hourly</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>WARNING - Capacity Utilization is Nearing Full</staticValue></dataSource></textItem></contents><style><CSS value="padding-right:25px;border:1pt solid silver"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue> WHEN Capacity Utilization % &gt;= 75% </staticValue></dataSource></textItem></contents><style><CSS value="padding-top:3px;padding-bottom:3px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px;width:700px;border:1pt solid silver"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;padding-bottom:5px;padding-left:20px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-top:15px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="pb"/>
					</defaultStyles>
				</style>
			</pageBody>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pg"/>
				</defaultStyles>
			</style>
		<pageSetup orientation="portrait"><customPaper width="15" height="15" unit="in"/></pageSetup></page></reportPages>
                    </layout>
                </layouts>
            <XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.2 Storage Infrastructure Executive Summary</reportName><queries><query name="Global Capacity Changes">
            <source>
                
            <sqlQuery dataSource="dwh_capacity" name="SQL5">
            <sqlText>SELECT     minDate.fullDate AS 'Previous Month Date',
    maxDate.fullDate AS 'Full Date',
    maxDate.rawTB AS 'Raw (TB)',
    maxDate.unconfiguredTB AS 'Unconfigured (TB)',
    maxDate.capacityTB AS 'Usable (TB)',
    maxDate.volTB AS 'Allocated (TB)',
    CASE    WHEN    maxDate.rawTB &gt; minDate.rawTB
        THEN    CONCAT('+', maxDate.rawTB - minDate.rawTB)
        ELSE    maxDate.rawTB - minDate.rawTB
    END     AS  'Raw Changes',
    maxDate.rawTB - minDate.rawTB AS 'Raw Change (Hidden)',
    CONCAT('(', ROUND((maxDate.rawTB - minDate.rawTB)/minDate.rawTB*100, 2), '%)') AS 'Raw Percentage',
    CASE    WHEN    maxDate.unconfiguredTB &gt; minDate.unconfiguredTB
        THEN    CONCAT('+', maxDate.unconfiguredTB - minDate.unconfiguredTB)
        ELSE    maxDate.unconfiguredTB - minDate.unconfiguredTB
    END     AS  'Unconfigured Changes',
    maxDate.unconfiguredTB - minDate.unconfiguredTB AS 'Unconfigured Change (Hidden)',
    CONCAT('(', ROUND((maxDate.unconfiguredTB - minDate.unconfiguredTB)/minDate.unconfiguredTB*100, 2), '%)') AS 'Unconfigured Percentage',
    CASE    WHEN    maxDate.capacityTB &gt; minDate.capacityTB
        THEN    CONCAT('+', maxDate.capacityTB - minDate.capacityTB)
        ELSE    maxDate.capacityTB - minDate.capacityTB
    END     AS  'Usable Changes',
    maxDate.capacityTB - minDate.capacityTB AS 'Usable Change (Hidden)',
    CONCAT('(', ROUND((maxDate.capacityTB - minDate.capacityTB)/minDate.capacityTB*100, 2), '%)') AS 'Usable Percentage',
    CASE    WHEN    maxDate.volTB &gt; minDate.volTB
        THEN    CONCAT('+', maxDate.volTB - minDate.volTB)
        ELSE    maxDate.volTB - minDate.VolTB
    END     AS  'Allocated Changes',
    maxDate.volTB - minDate.volTB AS 'Allocated Changes (Hidden)',
    CONCAT('(', ROUND((maxDate.volTB - minDate.volTB)/minDate.volTB*100, 2), '%)') AS 'Allocated Percentage'
FROM    (
    SELECT  dwh_capacity.date_dimension.fullDate AS fullDate,
        ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024/1024, 0) AS rawTB,
        ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.unconfiguredRawCapacityMB)/1024/1024, 0) AS unconfiguredTB,
        ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 0) AS capacityTB,
        ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024/1024, 0) AS volTB
    FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
    JOIN    dwh_capacity.date_dimension
    ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
    AND     dwh_capacity.date_dimension.latest = 1
    ) maxDate,
    (
    SELECT  d1.fullDate AS fullDate,
        ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024/1024, 0) AS rawTB,
        ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.unconfiguredRawCapacityMB)/1024/1024, 0) AS unconfiguredTB,
        ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 0) AS capacityTB,
        ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024/1024, 0) AS volTB
    FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
    JOIN    dwh_capacity.date_dimension d1
    ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = d1.tk
        JOIN    dwh_capacity.date_dimension d2
        ON  d2.latest = 1 
        AND     d1.future = 0 
        AND     d1.repMonthOrLatest = 1 
        AND     MONTH(d1.fullDate) = MONTH (d2.fullDate - INTERVAL 1 MONTH)
        AND     YEAR(d1.fullDate) = YEAR (d2.fullDate)
        ) minDate</sqlText>
        <mdProjectedItems><mdProjectedItem name="Previous Month Date"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Raw (TB)"/><mdProjectedItem name="Unconfigured (TB)"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Raw Changes"/><mdProjectedItem name="Raw Change (Hidden)"/><mdProjectedItem name="Raw Percentage"/><mdProjectedItem name="Unconfigured Changes"/><mdProjectedItem name="Unconfigured Change (Hidden)"/><mdProjectedItem name="Unconfigured Percentage"/><mdProjectedItem name="Usable Changes"/><mdProjectedItem name="Usable Change (Hidden)"/><mdProjectedItem name="Usable Percentage"/><mdProjectedItem name="Allocated Changes"/><mdProjectedItem name="Allocated Changes (Hidden)"/><mdProjectedItem name="Allocated Percentage"/></mdProjectedItems></sqlQuery></source>
            <selection><dataItem name="Previous Month Date"><expression>[SQL5].[Previous Month Date]</expression></dataItem><dataItem name="Full Date"><expression>[SQL5].[Full Date]</expression></dataItem><dataItem name="Raw (TB)"><expression>[SQL5].[Raw (TB)]</expression></dataItem><dataItem name="Unconfigured (TB)"><expression>[SQL5].[Unconfigured (TB)]</expression></dataItem><dataItem name="Usable (TB)"><expression>[SQL5].[Usable (TB)]</expression></dataItem><dataItem name="Allocated (TB)"><expression>[SQL5].[Allocated (TB)]</expression></dataItem><dataItem name="Raw Changes"><expression>[SQL5].[Raw Changes]</expression></dataItem><dataItem name="Raw Change (Hidden)"><expression>[SQL5].[Raw Change (Hidden)]</expression></dataItem><dataItem name="Raw Percentage"><expression>[SQL5].[Raw Percentage]</expression></dataItem><dataItem name="Unconfigured Changes"><expression>[SQL5].[Unconfigured Changes]</expression></dataItem><dataItem name="Unconfigured Change (Hidden)"><expression>[SQL5].[Unconfigured Change (Hidden)]</expression></dataItem><dataItem name="Unconfigured Percentage"><expression>[SQL5].[Unconfigured Percentage]</expression></dataItem><dataItem name="Usable Changes"><expression>[SQL5].[Usable Changes]</expression></dataItem><dataItem name="Usable Change (Hidden)"><expression>[SQL5].[Usable Change (Hidden)]</expression></dataItem><dataItem name="Usable Percentage"><expression>[SQL5].[Usable Percentage]</expression></dataItem><dataItem name="Allocated Changes"><expression>[SQL5].[Allocated Changes]</expression></dataItem><dataItem name="Allocated Changes (Hidden)"><expression>[SQL5].[Allocated Changes (Hidden)]</expression></dataItem><dataItem name="Allocated Percentage"><expression>[SQL5].[Allocated Percentage]</expression></dataItem><dataItem name="Available (TB)"><expression>[Usable (TB)]-[Allocated (TB)]</expression></dataItem><dataItem name="Available Changes"><expression>[Usable Changes]-[Allocated Changes]</expression></dataItem></selection>
        </query><query name="Capacity Trending">
            <source>
                
            <sqlQuery dataSource="dwh_capacity" name="SQL1" type="passThrough">
            <sqlText>SELECT     dwh_capacity.date_dimension.fullDate AS 'Date',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024/1024, 2) AS 'Raw (TB)',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Usable (TB)',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used (TB)',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB), 4) AS 'Used (%)',
    NULL AS 'Projected Raw (TB)',
    NULL AS 'Projected Usable (TB)',
    NULL AS 'Projected Used (TB)',
    NULL AS 'Projected Used (%)'
FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN    dwh_capacity.storage_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN    dwh_capacity.storage_pool_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
JOIN    dwh_capacity.date_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND     dwh_capacity.date_dimension.repMonthOrLatest = 1
AND    dwh_capacity.date_dimension.future=0
GROUP BY
    dwh_capacity.date_dimension.fullDate
</sqlText>
        <mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Raw (TB)"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Used (%)"/><mdProjectedItem name="Projected Raw (TB)"/><mdProjectedItem name="Projected Usable (TB)"/><mdProjectedItem name="Projected Used (TB)"/><mdProjectedItem name="Projected Used (%)"/></mdProjectedItems></sqlQuery></source>
            <selection><dataItem name="Date"><expression>[SQL1].[Date]</expression></dataItem><dataItem aggregate="total" name="Raw (TB)"><expression>[SQL1].[Raw (TB)]</expression></dataItem><dataItem name="Usable (TB)"><expression>[SQL1].[Usable (TB)]</expression></dataItem><dataItem aggregate="total" name="Used (TB)"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem aggregate="average" name="Used (%)"><expression>[SQL1].[Used (%)]</expression></dataItem></selection>
        </query><query name="Capacity by Data Center">
            <source>
                
            <sqlQuery dataSource="dwh_capacity" name="SQL2" type="passThrough">
            <sqlText>SELECT     dwh_capacity.storage_dimension.dataCenter AS 'Data Center',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024/1024, 2) AS 'Raw (TB)',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Usable (TB)',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used (TB)',
    ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, 
        dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, 
        dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024/1024, 2) AS 'Allocated (TB)'
FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN    dwh_capacity.storage_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN    dwh_capacity.storage_pool_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
JOIN    dwh_capacity.tier_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN    dwh_capacity.date_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND     dwh_capacity.date_dimension.latest = 1
GROUP BY
    dwh_capacity.storage_dimension.dataCenter</sqlText>
        <mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Raw (TB)"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Allocated (TB)"/></mdProjectedItems></sqlQuery></source>
            <selection><dataItem name="Data Center"><expression>[SQL2].[Data Center]</expression></dataItem><dataItem aggregate="total" name="Raw (TB)"><expression>[SQL2].[Raw (TB)]</expression></dataItem><dataItem aggregate="total" name="Usable (TB)"><expression>[SQL2].[Usable (TB)]</expression></dataItem><dataItem aggregate="total" name="Used (TB)"><expression>[SQL2].[Used (TB)]</expression></dataItem><dataItem aggregate="total" name="Allocated (TB)"><expression>[SQL2].[Allocated (TB)]</expression></dataItem></selection>
        </query><query name="Tier Capacity and Cost">
            <source>
                
            <sqlQuery dataSource="dwh_capacity" name="SQL3" type="passThrough">
            <sqlText>SELECT     dwh_capacity.tier_dimension.name AS 'Tier',
    dwh_capacity.tier_dimension.cost AS 'Cost',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Total (TB)',
    ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used (TB)',
    ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024,2) * dwh_capacity.tier_dimension.cost, 2) AS 'Total Tier Cost',
    ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024,2) * dwh_capacity.tier_dimension.cost, 2) AS 'Tier Cost'
FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN    dwh_capacity.storage_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN    dwh_capacity.storage_pool_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
JOIN    dwh_capacity.tier_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
AND     dwh_capacity.tier_dimension.tk &lt;&gt; 0
JOIN    dwh_capacity.date_dimension
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND     dwh_capacity.date_dimension.latest = 1
GROUP BY
    dwh_capacity.tier_dimension.tk</sqlText>
        <mdProjectedItems><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Total (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Total Tier Cost"/><mdProjectedItem name="Tier Cost"/></mdProjectedItems></sqlQuery></source>
            <selection><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Cost"><expression>[SQL3].[Cost]</expression></dataItem><dataItem name="Total (TB)"><expression>[SQL3].[Total (TB)]</expression></dataItem><dataItem aggregate="total" name="Used (TB)"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem aggregate="total" name="Free (TB)"><expression>[SQL3].[Total (TB)] - [SQL3].[Used (TB)]</expression></dataItem><dataItem name="Total Tier Cost"><expression>[SQL3].[Total Tier Cost]/1000</expression></dataItem><dataItem aggregate="total" name="Tier Used Cost"><expression>[SQL3].[Tier Cost]/1000</expression></dataItem><dataItem aggregate="total" name="Tier Free Cost"><expression>[Total Tier Cost] - [Tier Used Cost]</expression></dataItem></selection>
        </query><query name="Global Cost Changes">
            <source>
                
            <sqlQuery dataSource="dwh_capacity" name="SQL5">
            <sqlText>SELECT     minDate.fullDate AS 'Previous Month Date',
    maxDate.fullDate AS 'Full Date',
    maxDate.usableCost AS 'Usable Costs',
    maxDate.usedCost AS 'Used Costs',
    maxDate.freeCost AS 'Free Costs',
    maxDate.volCost AS 'Allocated Costs',
    CASE    WHEN    maxDate.usableCost &gt; minDate.usableCost
        THEN    CONCAT('+', maxDate.usableCost - minDate.usableCost)
        ELSE    maxDate.usableCost - minDate.usableCost
    END     AS  'Usable Changes',
    maxDate.usableCost - minDate.usableCost AS 'Usable Change (Hidden)',
    CONCAT('(', ROUND((maxDate.usableCost - minDate.usableCost)/minDate.usableCost*100, 2), '%)') AS 'Usable Percentage',
    CASE    WHEN    maxDate.usedCost &gt; minDate.usedCost
        THEN    CONCAT('+', maxDate.usedCost - minDate.usedCost)
        ELSE    maxDate.usedCost - minDate.usedCost
    END     AS  'Used Changes',
    maxDate.usedCost - minDate.usedCost AS 'Used Change (Hidden)',
    CONCAT('(', ROUND((maxDate.usedCost - minDate.usedCost)/minDate.usedCost*100, 2), '%)') AS 'Used Percentage',
    CASE    WHEN    maxDate.freeCost &gt; minDate.freeCost
        THEN    CONCAT('+', maxDate.freeCost - minDate.freeCost)
        ELSE    maxDate.freeCost - minDate.freeCost
    END     AS  'Free Changes',
    maxDate.freeCost - minDate.freeCost AS 'Free Change (Hidden)',
    CONCAT('(', ROUND((maxDate.freeCost - minDate.freeCost)/minDate.freeCost*100, 2), '%)') AS 'Free Percentage',
    CASE    WHEN    maxDate.volCost &gt; minDate.volCost
        THEN    CONCAT('+', maxDate.volCost - minDate.volCost)
        ELSE    maxDate.volCost - minDate.volCost
    END     AS  'Allocated Changes',
    maxDate.volCost - minDate.volCost AS 'Allocated Changes (Hidden)',
    CONCAT('(', ROUND((maxDate.volCost - minDate.volCost)/minDate.volCost*100, 2), '%)') AS 'Allocated Percentage'
FROM    (
    SELECT  x.fullDate AS fullDate,
        SUM(x.usableCost) AS usableCost,
        SUM(x.usedCost) AS usedCost,
        SUM(x.freeCost) AS freeCost,
        SUM(x.volCost) AS volCost
    FROM    (
        SELECT  dwh_capacity.tier_dimension.name AS tier,
            dwh_capacity.tier_dimension.cost AS cost,
            dwh_capacity.date_dimension.fullDate AS fullDate,
            ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024, 2) AS capacityGB,
            ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS usableCost,
            ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024, 2) AS usedGB,
            ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS usedCost,
            ROUND((SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) - SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB))/1024, 2) AS freeGB,
            ROUND(ROUND((SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) - SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB))/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS freeCost,
            ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024, 2) AS volGB,
            ROUND(ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS volCost
        FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
        JOIN    dwh_capacity.tier_dimension
        ON  dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
        JOIN    dwh_capacity.date_dimension
        ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
        AND     dwh_capacity.date_dimension.latest = 1
        GROUP BY
            tier
        ) X
    ) maxDate,
    (
    SELECT  y.fullDate AS fullDate,
        SUM(y.usableCost) AS usableCost,
        SUM(y.usedCost) AS usedCost,
        SUM(y.freeCost) AS freeCost,
        SUM(y.volCost) AS volCost
    FROM    (
        SELECT  dwh_capacity.tier_dimension.name AS tier,
            dwh_capacity.tier_dimension.cost AS cost,
            d1.fullDate AS fullDate,
            ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024, 2) AS capacityGB,
            ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS usableCost,
            ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024, 2) AS usedGB,
            ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS usedCost,
            ROUND((SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) - SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB))/1024, 2) AS freeGB,
            ROUND(ROUND((SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) - SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB))/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS freeCost,
            ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024, 2) AS volGB,
            ROUND(ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS volCost
        FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
        JOIN    dwh_capacity.tier_dimension
        ON  dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
        JOIN    dwh_capacity.date_dimension d1
        ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = d1.tk
        JOIN    dwh_capacity.date_dimension d2
        ON  d2.latest = 1 
        AND     d1.future = 0 
        AND     d1.repMonthOrLatest = 1 
        AND     MONTH(d1.fullDate) = MONTH (d2.fullDate - INTERVAL 1 MONTH)
        AND     YEAR(d1.fullDate) = YEAR (d2.fullDate)
        GROUP BY
            tier
        ) Y
        ) minDate</sqlText>
        <mdProjectedItems><mdProjectedItem name="Previous Month Date"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable Costs"/><mdProjectedItem name="Used Costs"/><mdProjectedItem name="Free Costs"/><mdProjectedItem name="Allocated Costs"/><mdProjectedItem name="Usable Changes"/><mdProjectedItem name="Usable Change (Hidden)"/><mdProjectedItem name="Usable Percentage"/><mdProjectedItem name="Used Changes"/><mdProjectedItem name="Used Change (Hidden)"/><mdProjectedItem name="Used Percentage"/><mdProjectedItem name="Free Changes"/><mdProjectedItem name="Free Change (Hidden)"/><mdProjectedItem name="Free Percentage"/><mdProjectedItem name="Allocated Changes"/><mdProjectedItem name="Allocated Changes (Hidden)"/><mdProjectedItem name="Allocated Percentage"/></mdProjectedItems></sqlQuery></source>
            <selection><dataItem name="Previous Month Date"><expression>[SQL5].[Previous Month Date]</expression></dataItem><dataItem name="Full Date"><expression>[SQL5].[Full Date]</expression></dataItem><dataItem name="Usable Costs"><expression>[SQL5].[Usable Costs]/1000000</expression></dataItem><dataItem name="Used Costs"><expression>[SQL5].[Used Costs]/1000000</expression></dataItem><dataItem name="Free Costs"><expression>[SQL5].[Free Costs]/1000000</expression></dataItem><dataItem name="Allocated Costs"><expression>[SQL5].[Allocated Costs]/1000000</expression></dataItem><dataItem name="Usable Changes"><expression>[SQL5].[Usable Changes]/1000000</expression></dataItem><dataItem name="Usable Change (Hidden)"><expression>[SQL5].[Usable Change (Hidden)]</expression></dataItem><dataItem name="Usable Percentage"><expression>[SQL5].[Usable Percentage]</expression></dataItem><dataItem name="Used Changes"><expression>[SQL5].[Used Changes]/1000000</expression></dataItem><dataItem name="Used Change (Hidden)"><expression>[SQL5].[Used Change (Hidden)]</expression></dataItem><dataItem name="Used Percentage"><expression>[SQL5].[Used Percentage]</expression></dataItem><dataItem name="Free Changes"><expression>[SQL5].[Free Changes]/1000000</expression></dataItem><dataItem name="Free Change (Hidden)"><expression>[SQL5].[Free Change (Hidden)]</expression></dataItem><dataItem name="Free Percentage"><expression>[SQL5].[Free Percentage]</expression></dataItem><dataItem name="Allocated Changes"><expression>[SQL5].[Allocated Changes]/1000000</expression></dataItem><dataItem name="Allocated Changes (Hidden)"><expression>[SQL5].[Allocated Changes (Hidden)]</expression></dataItem><dataItem name="Allocated Percentage"><expression>[SQL5].[Allocated Percentage]</expression></dataItem></selection>
        </query><query name="Total Cost vs Total IOPS">
            <source>
                
            <sqlQuery dataSource="dwh_performance" name="SQL4" type="passThrough">
            <sqlText>SELECT     cost.array AS 'Array',
    cost.usableCost AS 'Total Usable Cost',
    performance.totalIOPS AS 'Average Total IOPS'
FROM    (
    SELECT  x.array AS array,
        x.storageTk AS storageTk,
        SUM(x.usableCost) AS usableCost
    FROM    (
        SELECT  dwh_capacity.storage_dimension.name AS array,
            dwh_capacity.storage_dimension.tk AS storageTk,
            dwh_capacity.tier_dimension.name AS tier,
            dwh_capacity.tier_dimension.cost AS cost,
            dwh_capacity.date_dimension.fullDate AS fullDate,
            ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024, 2) AS capacityGB,
            ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS usableCost,
            ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024, 2) AS usedGB,
            ROUND(ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS usedCost,
            ROUND((SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) - SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB))/1024, 2) AS freeGB,
            ROUND(ROUND((SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) - SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB))/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS freeCost,
            ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024, 2) AS volGB,
            ROUND(ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, 
                dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024, 2) * dwh_capacity.tier_dimension.cost, 2) AS volCost
        FROM    dwh_capacity.storage_and_storage_pool_capacity_fact
        JOIN    dwh_capacity.storage_dimension
        ON  dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
        JOIN    dwh_capacity.tier_dimension
        ON  dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
        JOIN    dwh_capacity.date_dimension
        ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
        AND     dwh_capacity.date_dimension.latest = 1
        GROUP BY
            storageTk,
            tier
        ) X
    GROUP BY
        x.storageTk
    )  cost
JOIN    (
    SELECT  y.array AS array,
        y.storageTk AS storageTk,
        ROUND(AVG(y.totalIOPS),0) AS totalIOPS
    FROM    (
        SELECT  dwh_performance.storage_dimension.name AS array,
            dwh_performance.storage_dimension.tk AS storageTk,
            dwh_performance.time_dimension.hourDateTime,
            SUM(dwh_performance.disk_hourly_performance_fact.totalIops) totalIOPS
        FROM    dwh_performance.disk_hourly_performance_fact
        JOIN    dwh_performance.storage_dimension
        ON  dwh_performance.disk_hourly_performance_fact.storageTk = dwh_performance.storage_dimension.tk
        JOIN    dwh_performance.disk_dimension
        ON  dwh_performance.disk_hourly_performance_fact.diskTk = dwh_performance.disk_dimension.tk
        AND     dwh_performance.disk_dimension.role = 'DATA'
        JOIN    dwh_performance.time_dimension
        ON  dwh_performance.disk_hourly_performance_fact.timeTk = dwh_performance.time_dimension.tk
        GROUP BY
            dwh_performance.storage_dimension.tk,
            dwh_performance.time_dimension.hourDateTime
        ) Y
    GROUP BY
        y.storageTk
        ) performance
ON  cost.storageTk = performance.storageTk
GROUP BY
    cost.storageTk</sqlText>
        <mdProjectedItems><mdProjectedItem name="Array"/><mdProjectedItem name="Total Usable Cost"/><mdProjectedItem name="Average Total IOPS"/></mdProjectedItems></sqlQuery></source>
            <selection><dataItem name="Array"><expression>[SQL4].[Array]</expression></dataItem><dataItem aggregate="total" name="Total Usable Cost"><expression>[SQL4].[Total Usable Cost]/1000</expression></dataItem><dataItem aggregate="total" name="Average Total IOPS"><expression>[SQL4].[Average Total IOPS]</expression></dataItem></selection>
        </query><query name="Base Capacity Long Term Trend">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	dwh_capacity.date_dimension.dateYear AS 'Year',
	
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedrawcapacityMB)/1024/1024, 2) AS 'Used Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.unconfiguredRawCapacityMB)/1024/1024, 2) AS 'Unconfigured Raw (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.spareRawCapacityMB)/1024/1024, 2) AS 'Spare Raw (TB)',


	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'Projected Capacity (TB)',
	NULL AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.storage_and_storage_pool_capacity_fact 
ON  dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY


GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Year"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Used Raw Capacity (TB)"/><mdProjectedItem name="Unconfigured Raw (TB)"/><mdProjectedItem name="Spare Raw (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/><mdProjectedItem name="Projected Raw Capacity (TB)"/><mdProjectedItem name="Projected Capacity (TB)"/><mdProjectedItem name="Projected Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL1].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Year"><expression>[SQL1].[Year]</expression></dataItem><dataItem aggregate="total" name="Raw Capacity (TB)"><expression>[SQL1].[Raw Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Used Raw Capacity (TB)"><expression>[SQL1].[Used Raw Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Unconfigured Raw (TB)"><expression>[SQL1].[Unconfigured Raw (TB)]</expression></dataItem><dataItem aggregate="total" name="Spare Raw (TB)"><expression>[SQL1].[Spare Raw (TB)]</expression></dataItem><dataItem aggregate="total" name="Capacity (TB)"><expression>[SQL1].[Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Used Capacity (TB)"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Provisioned (TB)"><expression>[SQL1].[Provisioned (TB)]</expression></dataItem><dataItem aggregate="total" name="Volume Consumed Capacity (TB)"><expression>[SQL1].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)"><expression>[SQL1].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL1].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Capacity (TB)"><expression>[SQL1].[Projected Raw Capacity (TB)]</expression></dataItem><dataItem name="Projected Capacity (TB)"><expression>[SQL1].[Projected Capacity (TB)]</expression></dataItem><dataItem name="Projected Used Capacity (TB)"><expression>[SQL1].[Projected Used Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Free Capacity (TB)"><expression>[Capacity (TB)]-[Used Capacity (TB)]</expression></dataItem><dataItem name="% Free"><expression>[Free Capacity (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="% Used"><expression>[Used Capacity (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="Data Item1"><expression>[Cost]+4000</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints></query><query name="Base Capacity">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	dwh_capacity.date_dimension.dateYear AS 'Year',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedrawcapacityMB)/1024/1024, 2) AS 'Used Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.unconfiguredRawCapacityMB)/1024/1024, 2) AS 'Unconfigured Raw (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.spareRawCapacityMB)/1024/1024, 2) AS 'Spare Raw (TB)',


	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'Projected Capacity (TB)',
	NULL AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Year"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Used Raw Capacity (TB)"/><mdProjectedItem name="Unconfigured Raw (TB)"/><mdProjectedItem name="Spare Raw (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/><mdProjectedItem name="Projected Raw Capacity (TB)"/><mdProjectedItem name="Projected Capacity (TB)"/><mdProjectedItem name="Projected Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL1].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Year"><expression>[SQL1].[Year]</expression></dataItem><dataItem aggregate="total" name="Raw Capacity (TB)"><expression>[SQL1].[Raw Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Used Raw Capacity (TB)"><expression>[SQL1].[Used Raw Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Unconfigured Raw (TB)"><expression>[SQL1].[Unconfigured Raw (TB)]</expression></dataItem><dataItem aggregate="total" name="Spare Raw (TB)"><expression>[SQL1].[Spare Raw (TB)]</expression></dataItem><dataItem aggregate="total" name="Capacity (TB)"><expression>[SQL1].[Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Used Capacity (TB)"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Provisioned (TB)"><expression>[SQL1].[Provisioned (TB)]</expression></dataItem><dataItem aggregate="total" name="Volume Consumed Capacity (TB)"><expression>[SQL1].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)"><expression>[SQL1].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL1].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Capacity (TB)"><expression>[SQL1].[Projected Raw Capacity (TB)]</expression></dataItem><dataItem name="Projected Capacity (TB)"><expression>[SQL1].[Projected Capacity (TB)]</expression></dataItem><dataItem name="Projected Used Capacity (TB)"><expression>[SQL1].[Projected Used Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="Free Capacity (TB)"><expression>[Capacity (TB)]-[Used Capacity (TB)]</expression></dataItem><dataItem name="% Free"><expression>[Free Capacity (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="% Used"><expression>[Used Capacity (TB)]/[Capacity (TB)]</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints></query><query name="Storage Efficency Savings">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
/*
dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB/1024/1024 * ((1 - dwh_capacity.storage_and_storage_pool_capacity_fact.dedupeRatio)/dwh_capacity.storage_and_storage_pool_capacity_fact.dedupeRatio) 'Dedupe Savings (TB)',

dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB/1024/1024 * ((1 - dwh_capacity.storage_and_storage_pool_capacity_fact.compressionRatio)/dwh_capacity.storage_and_storage_pool_capacity_fact.compressionRatio) 'Compression Savings (TB)',
*/

(SELECT 
(SUM(ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB * ((1-dwh_inventory.internal_volume.dedupeRatio)/dwh_inventory.internal_volume.dedupeRatio),2)))/1024/1024

FROM dwh_inventory.storage
JOIN dwh_inventory.internal_volume
ON dwh_inventory.internal_volume.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.internal_volume.dedupeRatio is not null 
AND dwh_inventory.storage.id=dwh_capacity.storage_dimension.id
GROUP BY dwh_inventory.storage.id) as 'Dedupe Savings (TB)',

(SELECT 
(SUM(ROUND(dwh_inventory.internal_volume.totalUsedCapacityMB * ((1-dwh_inventory.internal_volume.compressionRatio)/dwh_inventory.internal_volume.compressionRatio),2)))/1024/1024

FROM dwh_inventory.storage
JOIN dwh_inventory.internal_volume
ON dwh_inventory.internal_volume.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.internal_volume.dedupeRatio is not null 
AND dwh_inventory.storage.id=dwh_capacity.storage_dimension.id
GROUP BY dwh_inventory.storage.id) as 'Compression Savings (TB)',


	
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)'



FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isvirtual = 0
AND	dwh_capacity.storage_dimension.microcodeversion LIKE CONCAT('%','clustered','%')
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Dedupe Savings (TB)"/><mdProjectedItem name="Compression Savings (TB)"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[SQL1].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL1].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL1].[Provisioned (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)" aggregate="total"><expression>[SQL1].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Subscription %"><expression>([Internal Volume Allocated Capacity (TB)]+[Provisioned (TB)]) / [Capacity (TB)]</expression></dataItem><dataItem name="Thin Savings (TB)" aggregate="total"><expression>IF([Subscription %]&gt;1) THEN (([Subscription %]-1)*[Capacity (TB)]) ELSE (0)</expression></dataItem><dataItem name="Dedupe Savings (TB)" aggregate="total"><expression>[SQL1].[Dedupe Savings (TB)]</expression></dataItem><dataItem name="Comp Savings (TB)" aggregate="total"><expression>[SQL1].[Compression Savings (TB)]</expression></dataItem><dataItem name="Total Efficiency Savings (TB)" aggregate="total"><expression>[Thin Savings (TB)] + IF([Dedupe Savings (TB)] is not null) THEN ([Dedupe Savings (TB)]) ELSE (0) + IF([Comp Savings (TB)] is not null) THEN ([Comp Savings (TB)]) ELSE (0)</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Thin Cost Savings"><expression>([Cost]*([Thin Savings (TB)]*1024))</expression></dataItem><dataItem name="Dedupe Cost Savings"><expression>([Cost]*([Dedupe Savings (TB)]*1024))</expression></dataItem><dataItem name="Comp Cost Savings"><expression>([Cost]*([Comp Savings (TB)]*1024))</expression></dataItem><dataItem name="Total Efficiency Cost Savings"><expression>[Cost]*([Total Efficiency Savings (TB)]*1024)</expression></dataItem></selection>
		</query><query name="Node Perf">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT

perf.node as 'Storage Node',
perf.NodeAllocatedTB as 'Allocated Capacity TB',
perf.NodeUsedTB as 'Used Capacity TB',
perf.storage as 'Storage Cluster',
perf.vendor as 'Vendor',
perf.model as 'Model',
perf.totaliops as 'Total IOpS',
perf.peakiops as 'Peak IOpS',
perf.totalmbps as 'Total MBps',
perf.peakmbps as 'Peak MBps',
perf.latency as 'Avg Latency (ms)',
perf.peaklatency as 'Peak Latency (ms)',
perf.utilization as 'Avg CPU Utilization',
perf.peakutilization as 'Peak CPU Utilization',
perf.time as 'Time',
perf.fulldate as 'Full Date'

FROM (


SELECT
dwh_performance.storage_node_dimension.name as node,
dwh_performance.storage_dimension.tk as storagetk,
dwh_performance.storage_dimension.name as storage,
dwh_performance.storage_dimension.manufacturer as vendor,
dwh_performance.storage_dimension.model as model,

(SELECT ROUND(SUM(dwh_inventory.storage_pool.totalAllocatedCapacityMB)/1024/1024,2)
FROM dwh_inventory.storage_pool
JOIN  dwh_inventory.storage_node_to_storage_pool ON dwh_inventory.storage_node_to_storage_pool.storagepoolid=dwh_inventory.storage_pool.id
JOIN dwh_inventory.storage_node ON  dwh_inventory.storage_node_to_storage_pool.storagenodeid=dwh_inventory.storage_node.id
WHERE dwh_performance.storage_node_dimension.id=dwh_inventory.storage_node.id
GROUP BY dwh_inventory.storage_node.id ) as 'NodeAllocatedTB',

(SELECT ROUND(SUM(dwh_inventory.storage_pool.totalUsedCapacityMB)/1024/1024,2)
FROM dwh_inventory.storage_pool
JOIN  dwh_inventory.storage_node_to_storage_pool ON dwh_inventory.storage_node_to_storage_pool.storagepoolid=dwh_inventory.storage_pool.id
JOIN dwh_inventory.storage_node ON  dwh_inventory.storage_node_to_storage_pool.storagenodeid=dwh_inventory.storage_node.id
WHERE dwh_performance.storage_node_dimension.id=dwh_inventory.storage_node.id
GROUP BY dwh_inventory.storage_node.id ) as 'NodeUsedTB',


SUM(dwh_performance.storage_node_hourly_performance_fact.totaliops) as totaliops,
MAX(dwh_performance.storage_node_hourly_performance_fact.totaliopsmax) as peakiops,
SUM(dwh_performance.storage_node_hourly_performance_fact.totalthroughput) as totalmbps,
MAX(dwh_performance.storage_node_hourly_performance_fact.totalthroughputmax) as peakmbps,
AVG(dwh_performance.storage_node_hourly_performance_fact.totalresponsetime) as latency,
MAX(dwh_performance.storage_node_hourly_performance_fact.totalresponsetimemax) as peaklatency,
AVG(dwh_performance.storage_node_hourly_performance_fact.utilization) as utilization,
MAX(dwh_performance.storage_node_hourly_performance_fact.utilizationmax) as peakutilization,
dwh_performance.time_dimension.hourdatetime as time,
dwh_performance.date_dimension.fulldate as fulldate

FROM dwh_performance.storage_node_hourly_performance_fact
JOIN dwh_performance.storage_node_dimension
ON dwh_performance.storage_node_dimension.tk=dwh_performance.storage_node_hourly_performance_fact.storagenodetk
JOIN dwh_performance.storage_dimension
ON dwh_performance.storage_dimension.tk=dwh_performance.storage_node_hourly_performance_fact.storagetk
AND dwh_performance.storage_dimension.manufacturer ='netapp'
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.storage_node_hourly_performance_fact.timetk
JOIN dwh_performance.date_dimension
ON dwh_performance.date_dimension.tk=dwh_performance.storage_node_hourly_performance_fact.datetk

GROUP BY dwh_performance.storage_node_dimension.tk, dwh_performance.time_dimension.tk, dwh_performance.date_dimension.tk

) perf



</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Node"/><mdProjectedItem name="Allocated Capacity TB"/><mdProjectedItem name="Used Capacity TB"/><mdProjectedItem name="Storage Cluster"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Total MBps"/><mdProjectedItem name="Peak MBps"/><mdProjectedItem name="Avg Latency (ms)"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Avg CPU Utilization"/><mdProjectedItem name="Peak CPU Utilization"/><mdProjectedItem name="Time"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Node"><expression>[SQL1].[Storage Node]</expression></dataItem><dataItem name="Allocated Capacity TB"><expression>[SQL1].[Allocated Capacity TB]</expression></dataItem><dataItem name="Used Capacity TB"><expression>[SQL1].[Used Capacity TB]</expression></dataItem><dataItem name="Storage Cluster"><expression>[SQL1].[Storage Cluster]</expression></dataItem><dataItem name="Vendor"><expression>[SQL1].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem aggregate="average" name="Total IOpS"><expression>[SQL1].[Total IOpS]</expression></dataItem><dataItem aggregate="maximum" name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem aggregate="total" name="Total MBps"><expression>[SQL1].[Total MBps]</expression></dataItem><dataItem aggregate="maximum" name="Peak MBps"><expression>[SQL1].[Peak MBps]</expression></dataItem><dataItem aggregate="average" name="Avg Latency (ms)"><expression>[SQL1].[Avg Latency (ms)]</expression></dataItem><dataItem aggregate="maximum" name="Peak Latency (ms)"><expression>[SQL1].[Peak Latency (ms)]</expression></dataItem><dataItem aggregate="average" name="Avg CPU Utilization"><expression>[SQL1].[Avg CPU Utilization]</expression></dataItem><dataItem name="Peak CPU Utilization" aggregate="average"><expression>[SQL1].[Peak CPU Utilization]</expression></dataItem><dataItem name="Time"><expression>[SQL1].[Time]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem></selection>
		</query><query name="Node Perf - Long Term Trend">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT

perf.node as 'Storage Node',
perf.NodeAllocatedTB as 'Allocated Capacity TB',
perf.NodeUsedTB as 'Used Capacity TB',
perf.storage as 'Storage Cluster',
perf.vendor as 'Vendor',
perf.model as 'Model',
perf.totaliops as 'Total IOpS',
perf.peakiops as 'Peak IOpS',
perf.totalmbps as 'Total MBps',
perf.peakmbps as 'Peak MBps',
perf.latency as 'Avg Latency (ms)',
perf.peaklatency as 'Peak Latency (ms)',
perf.utilization as 'Avg CPU Utilization',
perf.peakutilization as 'Peak CPU Utilization',
perf.fulldate as 'Full Date'

FROM (


SELECT
dwh_performance.storage_node_dimension.name as node,
dwh_performance.storage_dimension.tk as storagetk,
dwh_performance.storage_dimension.name as storage,
dwh_performance.storage_dimension.manufacturer as vendor,
dwh_performance.storage_dimension.model as model,

(SELECT ROUND(SUM(dwh_inventory.storage_pool.totalAllocatedCapacityMB)/1024/1024,2)
FROM dwh_inventory.storage_pool
JOIN  dwh_inventory.storage_node_to_storage_pool ON dwh_inventory.storage_node_to_storage_pool.storagepoolid=dwh_inventory.storage_pool.id
JOIN dwh_inventory.storage_node ON  dwh_inventory.storage_node_to_storage_pool.storagenodeid=dwh_inventory.storage_node.id
WHERE dwh_performance.storage_node_dimension.id=dwh_inventory.storage_node.id
GROUP BY dwh_inventory.storage_node.id ) as 'NodeAllocatedTB',

(SELECT ROUND(SUM(dwh_inventory.storage_pool.totalUsedCapacityMB)/1024/1024,2)
FROM dwh_inventory.storage_pool
JOIN  dwh_inventory.storage_node_to_storage_pool ON dwh_inventory.storage_node_to_storage_pool.storagepoolid=dwh_inventory.storage_pool.id
JOIN dwh_inventory.storage_node ON  dwh_inventory.storage_node_to_storage_pool.storagenodeid=dwh_inventory.storage_node.id
WHERE dwh_performance.storage_node_dimension.id=dwh_inventory.storage_node.id
GROUP BY dwh_inventory.storage_node.id ) as 'NodeUsedTB',


SUM(dwh_performance.storage_node_daily_performance_fact.totaliops) as totaliops,
MAX(dwh_performance.storage_node_daily_performance_fact.totaliopsmax) as peakiops,
SUM(dwh_performance.storage_node_daily_performance_fact.totalthroughput) as totalmbps,
MAX(dwh_performance.storage_node_daily_performance_fact.totalthroughputmax) as peakmbps,
AVG(dwh_performance.storage_node_daily_performance_fact.totalresponsetime) as latency,
MAX(dwh_performance.storage_node_daily_performance_fact.totalresponsetimemax) as peaklatency,
AVG(dwh_performance.storage_node_daily_performance_fact.utilization) as utilization,
MAX(dwh_performance.storage_node_daily_performance_fact.utilizationmax) as peakutilization,

dwh_performance.date_dimension.fulldate as fulldate

FROM dwh_performance.storage_node_daily_performance_fact
JOIN dwh_performance.storage_node_dimension
ON dwh_performance.storage_node_dimension.tk=dwh_performance.storage_node_daily_performance_fact.storagenodetk
JOIN dwh_performance.storage_dimension
ON dwh_performance.storage_dimension.tk=dwh_performance.storage_node_daily_performance_fact.storagetk
AND dwh_performance.storage_dimension.manufacturer ='netapp'
JOIN dwh_performance.date_dimension
ON dwh_performance.date_dimension.tk=dwh_performance.storage_node_daily_performance_fact.datetk

GROUP BY dwh_performance.storage_node_dimension.tk, dwh_performance.date_dimension.tk

) perf



</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Node"/><mdProjectedItem name="Allocated Capacity TB"/><mdProjectedItem name="Used Capacity TB"/><mdProjectedItem name="Storage Cluster"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Total MBps"/><mdProjectedItem name="Peak MBps"/><mdProjectedItem name="Avg Latency (ms)"/><mdProjectedItem name="Peak Latency (ms)"/><mdProjectedItem name="Avg CPU Utilization"/><mdProjectedItem name="Peak CPU Utilization"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Node"><expression>[SQL6].[Storage Node]</expression></dataItem><dataItem name="Allocated Capacity TB"><expression>[SQL6].[Allocated Capacity TB]</expression></dataItem><dataItem name="Used Capacity TB"><expression>[SQL6].[Used Capacity TB]</expression></dataItem><dataItem name="Storage Cluster"><expression>[SQL6].[Storage Cluster]</expression></dataItem><dataItem name="Vendor"><expression>[SQL6].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL6].[Model]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL6].[Total IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL6].[Peak IOpS]</expression></dataItem><dataItem name="Total MBps"><expression>[SQL6].[Total MBps]</expression></dataItem><dataItem name="Peak MBps"><expression>[SQL6].[Peak MBps]</expression></dataItem><dataItem name="Avg Latency (ms)"><expression>[SQL6].[Avg Latency (ms)]</expression></dataItem><dataItem name="Peak Latency (ms)"><expression>[SQL6].[Peak Latency (ms)]</expression></dataItem><dataItem name="Avg CPU Utilization"><expression>[SQL6].[Avg CPU Utilization]</expression></dataItem><dataItem name="Peak CPU Utilization"><expression>[SQL6].[Peak CPU Utilization]</expression></dataItem><dataItem name="Full Date"><expression>[SQL6].[Full Date]</expression></dataItem></selection>
		</query><query name="Workload Growth and Capability">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 
		dwh_performance.storage_dimension.id AS 'storageId',
		dwh_performance.storage_pool_dimension.id AS 'storagePoolId',

(

SELECT

SUM(cap.pooliopscapability) 

FROM
(

SELECT
	
	IF (dwh_inventory.storage_pool.name LIKE '%:%',
		SUBSTRING_INDEX(dwh_inventory.storage_pool.name,':',1),
        dwh_inventory.storage.name) AS 'storageName',
    dwh_inventory.storage.id AS 'storageId',
    IF (dwh_inventory.storage_pool.name LIKE '%:%',
		SUBSTRING_INDEX(dwh_inventory.storage_pool.name,':',-1),
        dwh_inventory.storage_pool.name) AS 'storagePoolName',
    dwh_inventory.storage_pool.id AS 'storagePoolId',
    
    dwh_inventory.storage_pool.usesFlashPools AS 'usesFlashPools',
    IF(dwh_inventory.storage_pool.usesFlashPools = 1,
				COUNT(DISTINCT 
					CASE 
						WHEN dwh_inventory.disk.type NOT LIKE 'SSD' THEN dwh_inventory.disk.id
					END),
				COUNT(DISTINCT dwh_inventory.disk.id)) AS 'diskCount',
			CASE
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 4 THEN 3000
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 3 THEN 200
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 2 THEN 170
				ELSE 75
			END AS 'diskIOpSCapability',
			IF(dwh_inventory.storage_pool.usesFlashPools = 1,
				COUNT(DISTINCT CASE 
					WHEN dwh_inventory.disk.type NOT LIKE 'SSD' THEN dwh_inventory.disk.id
					END) * 
				(CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 4 THEN 3000
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 3 THEN 200
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 2 THEN 170
					ELSE 75
					END ),
				COUNT(DISTINCT dwh_inventory.disk.id) *
				(CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 4 THEN 3000
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 3 THEN 200
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 2 THEN 170
					ELSE 75
				END ) ) AS 'poolIopsCapability',
                CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 4 THEN 'SSD'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 3 THEN 'SAS'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC' THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 2 THEN 'FC'
                     WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 1 THEN 'SATA'   
					ELSE 'Not Defined'
					END AS 'diskType',
                    MIN(dwh_inventory.disk.speed) AS 'diskSpeed',
					dwh_inventory.disk.capacityGB AS 'diskCapacityGB'
    
FROM dwh_inventory.storage

JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage.id = dwh_inventory.storage_pool.storageId


LEFT JOIN dwh_inventory.storage_pool_to_disk
ON dwh_inventory.storage_pool.id = dwh_inventory.storage_pool_to_disk.storagePoolId

LEFT JOIN dwh_inventory.disk
ON dwh_inventory.storage_pool_to_disk.diskId = dwh_inventory.disk.id

WHERE dwh_inventory.storage_pool.name NOT LIKE CONCAT('%','root','%')
AND dwh_inventory.storage.manufacturer='netapp'

GROUP BY dwh_inventory.storage_pool.id ) cap

) as 'Capability',
		
	SUM(dwh_performance.disk_daily_performance_fact.totaliopsmax) AS 'avgIOps',

                     (SELECT SUM(dwh_performance.disk_daily_performance_fact.totaliopsmax) FROM 
	dwh_performance.disk_daily_performance_fact
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.disk_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.disk_daily_performance_fact.storagePoolTk
		
	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.disk_daily_performance_fact.datetk
        	
WHERE dwh_performance.date_dimension.fullDate &gt;=(SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.disk_daily_performance_fact
ON dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 0 DAY ) as 'Current IOpS',



	dwh_performance.date_dimension.fulldate as 'fulldate',
	dwh_performance.date_dimension.repMonthOrLatest as 'repmonthorlatest'
	
	FROM 	dwh_performance.disk_daily_performance_fact
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.disk_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.disk_daily_performance_fact.storagePoolTk
		
	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.disk_daily_performance_fact.datetk
        AND     dwh_performance.date_dimension.repmonth=1
	
WHERE dwh_performance.date_dimension.fullDate &gt;=(SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.disk_daily_performance_fact
ON dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 730 DAY
	
GROUP BY dwh_performance.storage_pool_dimension.id, dwh_performance.date_dimension.fulldate</sqlText>
		<mdProjectedItems><mdProjectedItem name="storageId"/><mdProjectedItem name="storagePoolId"/><mdProjectedItem name="Capability"/><mdProjectedItem name="avgIOps"/><mdProjectedItem name="Current IOpS"/><mdProjectedItem name="fulldate"/><mdProjectedItem name="repmonthorlatest"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="storageId"><expression>[SQL8].[storageId]</expression></dataItem><dataItem name="storagePoolId"><expression>[SQL8].[storagePoolId]</expression></dataItem><dataItem name="Capability"><expression>[SQL8].[Capability]</expression></dataItem><dataItem name="avgIOps" aggregate="total"><expression>[SQL8].[avgIOps]</expression></dataItem><dataItem name="fulldate"><expression>[SQL8].[fulldate]</expression></dataItem><dataItem name="repmonthorlatest"><expression>[SQL8].[repmonthorlatest]</expression></dataItem><dataItem name="Data Item1"><expression>[Capability]</expression></dataItem><dataItem name="Workload %"><expression>[Current IOpS]/[Capability]</expression></dataItem><dataItem name="Current IOpS"><expression>[SQL8].[Current IOpS]</expression></dataItem></selection>
		</query><query name="All Nodes">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_inventory.storage.name as 'Cluster',
dwh_inventory.storage_node.name as 'Node'

FROM dwh_inventory.storage_node
JOIN dwh_inventory.storage
ON   dwh_inventory.storage.id=dwh_inventory.storage_node.storageid
AND dwh_inventory.storage.manufacturer='netapp'

GROUP BY dwh_inventory.storage.name, dwh_inventory.storage_node.name

ORDER BY dwh_inventory.storage.name
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster"/><mdProjectedItem name="Node"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Node"><expression>[SQL9].[Node]</expression></dataItem><dataItem name="Cluster"><expression>[SQL9].[Cluster]</expression></dataItem></selection>
		</query><query name="Workload Growth">
			<source>
				
			<sqlQuery name="SQL10" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 

volperf.Node as 'Node',

SUBSTR(volperf.Aggregate,LOCATE(':',volperf.Aggregate)+1, 100)  as 'Aggregate',
volperf.AvgIOps as 'Total IOpS',
volperf.PeakIOps as 'Max Total IOpS',
volperf.IODensity as 'IO Density',

nodeperf.Utilization as 'CPU Utilization',
nodeperf.PeakUtilization as 'Peak CPU Utilization',
nodedisk.MaxSupportedIOpS as 'Max Supported IOpS',
nodedisk.disktype as 'Disk Type',
nodedisk.capacityGB as 'Total Capacity GB',
nodedisk.usedCapacityGB as 'Total Used GB',

 (SELECT SUM(dwh_performance.disk_daily_performance_fact.totaliopsmax) FROM 
	dwh_performance.disk_daily_performance_fact
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.disk_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.disk_daily_performance_fact.storagePoolTk
		
	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.disk_daily_performance_fact.datetk
        	
WHERE dwh_performance.date_dimension.fullDate &gt;=(SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.disk_daily_performance_fact
ON dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 0 DAY ) as 'Current IOpS'


FROM

(

SELECT
dwh_performance.storage_node_dimension.name as 'Node',
dwh_performance.storage_node_dimension.id as 'volnodeid',
dwh_performance.storage_pool_dimension.name as 'Aggregate',
dwh_performance.storage_pool_dimension.id as poolid,
ROUND(MAX(dwh_performance.internal_volume_hourly_performance_fact.totaliops),0) as 'AvgIOps',
ROUND(MAX(dwh_performance.internal_volume_hourly_performance_fact.totaliopsmax),0) as 'PeakIOps',
ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totaliodensity),0) as 'IODensity'

FROM dwh_performance.internal_volume_hourly_performance_fact
JOIN dwh_performance.storage_node_dimension
ON dwh_performance.storage_node_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagenodetk
JOIN dwh_performance.storage_pool_dimension
ON dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagepooltk
AND dwh_performance.storage_pool_dimension.name&lt;&gt;'N/A'
AND dwh_performance.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')

GROUP BY dwh_performance.storage_node_dimension.name, dwh_performance.storage_pool_dimension.name ) volperf

JOIN
(
SELECT
dwh_performance.storage_node_dimension.id as 'nodeid',
ROUND((dwh_performance.storage_node_hourly_performance_fact.utilization),2) as 'Utilization',
ROUND((dwh_performance.storage_node_hourly_performance_fact.utilizationmax),2) as 'PeakUtilization'

FROM dwh_performance.storage_node_hourly_performance_fact
JOIN dwh_performance.storage_node_dimension
ON dwh_performance.storage_node_dimension.tk=dwh_performance.storage_node_hourly_performance_fact.storagenodetk

GROUP BY dwh_performance.storage_node_dimension.id) nodeperf ON nodeperf.nodeid=volperf.volnodeid

JOIN

(
select
dwh_inventory.storage_node.id as disknodeid,
dwh_inventory.storage_pool.id as poolid,
dwh_inventory.storage_node.name as 'node',
dwh_inventory.storage_pool.name as 'pool',
dwh_inventory.storage_pool.dataAllocatedCapacityMB/1024 as CapacityGB,
dwh_inventory.storage_pool.dataUsedCapacityMB/1024 as UsedCapacityGB,
-- GROUP_CONCAT(DISTINCT dwh_inventory.disk.type) as 'DiskType',
dwh_inventory.disk.type as 'DiskType',
COUNT(DISTINCT dwh_inventory.disk.id) AS DiskCount,

	    CASE
	  WHEN dwh_inventory.disk.type = 'SSD' THEN 3000 
	  WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 200
	  WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 7200 THEN 85
	  WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 200
	  WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 170
	  WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 170
	  WHEN dwh_inventory.disk.type = 'SATA' THEN 75
	  	END AS DiskIOpSCapability,
        COUNT(DISTINCT dwh_inventory.disk.id) * 
			(CASE
				WHEN dwh_inventory.disk.type = 'SSD' THEN 3000
				WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 200
				WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 7200 THEN 85
				WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 200
				WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 170
				WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 170
				WHEN dwh_inventory.disk.type = 'SATA' THEN 75
				END)  AS MaxSupportedIOpS



FROM dwh_inventory.storage_node
JOIN dwh_inventory.storage_node_to_storage_pool
ON dwh_inventory.storage_node_to_storage_pool.storagenodeid=dwh_inventory.storage_node.id
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.storage_node_to_storage_pool.storagepoolid
JOIN dwh_inventory.storage_pool_to_disk
ON dwh_inventory.storage_pool_to_disk.storagepoolid=dwh_inventory.storage_pool.id
JOIN dwh_inventory.disk
ON dwh_inventory.disk.id=dwh_inventory.storage_pool_to_disk.diskid


GROUP by dwh_inventory.storage_node.id, dwh_inventory.storage_pool.id, dwh_inventory.disk.type  ) nodedisk ON nodedisk.disknodeid=volperf.volnodeid AND nodedisk.poolid=volperf.poolid























</sqlText>
		<mdProjectedItems><mdProjectedItem name="Node"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/><mdProjectedItem name="IO Density"/><mdProjectedItem name="CPU Utilization"/><mdProjectedItem name="Peak CPU Utilization"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Disk Type"/><mdProjectedItem name="Total Capacity GB"/><mdProjectedItem name="Total Used GB"/><mdProjectedItem name="Current IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Node"><expression>[SQL10].[Node]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL10].[Aggregate]</expression></dataItem><dataItem name="avgIOpS"><expression>[SQL10].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL10].[Max Total IOpS]</expression></dataItem><dataItem name="IO Density"><expression>[SQL10].[IO Density]</expression></dataItem><dataItem name="CPU Utilization"><expression>[SQL10].[CPU Utilization]</expression></dataItem><dataItem name="Peak CPU Utilization"><expression>[SQL10].[Peak CPU Utilization]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL10].[Max Supported IOpS]</expression></dataItem><dataItem name="Disk Type"><expression>[SQL10].[Disk Type]</expression></dataItem><dataItem name="Total Capacity GB"><expression>[SQL10].[Total Capacity GB]</expression></dataItem><dataItem name="Total Used GB"><expression>[SQL10].[Total Used GB]</expression></dataItem><dataItem name="Current IOpS"><expression>[SQL10].[Current IOpS]</expression></dataItem><dataItem name="Workload %"><expression>[Current IOpS]/[Max Supported IOpS]</expression></dataItem><dataItem name="Data Item1"><expression>[Capability]</expression></dataItem></selection>
		</query><query name="Head Room Query - Release 4">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 

volperf.Node as 'Storage Name',
SUBSTR(volperf.Aggregate,LOCATE(':',volperf.Aggregate)+1, 100)  as 'Aggregate',
volperf.AvgIOps as 'Total IOpS',
volperf.PeakIOps as 'Max Total IOpS',
volperf.IODensity as 'IO Density',

CASE 
WHEN volperf.IODensity &lt;=128 THEN 'Capacity'
WHEN volperf.IODensity  &lt;=512 THEN 'Value'
WHEN volperf.IODensity  &lt;=1024 THEN 'Performance'
WHEN volperf.IODensity  &lt;=2048 THEN 'High Read'
WHEN volperf.IODensity  &lt;=4096 THEN 'High Write'
WHEN volperf.IODensity  &lt;=8192 THEN 'Extreme'
END as 'Ranges',

nodeperf.Utilization as 'CPU Utilization',
nodeperf.PeakUtilization as 'Peak CPU Utilization',
nodedisk.MaxSupportedIOpS as 'Max Supported IOpS',
nodedisk.disktype as 'Disk Type',
nodedisk.capacityGB as 'Total Capacity GB',
nodedisk.usedCapacityGB as 'Total Used GB'

FROM

(

SELECT
dwh_performance.storage_node_dimension.name as 'Node',
dwh_performance.storage_node_dimension.id as 'volnodeid',
dwh_performance.storage_pool_dimension.name as 'Aggregate',
dwh_performance.storage_pool_dimension.id as poolid,
ROUND(MAX(dwh_performance.internal_volume_hourly_performance_fact.totaliops),0) as 'AvgIOps',
ROUND(MAX(dwh_performance.internal_volume_hourly_performance_fact.totaliopsmax),0) as 'PeakIOps',
ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totaliodensity),0) as 'IODensity'

FROM dwh_performance.internal_volume_hourly_performance_fact
JOIN dwh_performance.storage_node_dimension
ON dwh_performance.storage_node_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagenodetk
JOIN dwh_performance.storage_pool_dimension
ON dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.storagepooltk
AND dwh_performance.storage_pool_dimension.name&lt;&gt;'N/A'
AND dwh_performance.storage_pool_dimension.name NOT LIKE CONCAT('%','root','%')

GROUP BY dwh_performance.storage_node_dimension.name, dwh_performance.storage_pool_dimension.name ) volperf

JOIN
(
SELECT
dwh_performance.storage_node_dimension.id as 'nodeid',
ROUND((dwh_performance.storage_node_hourly_performance_fact.utilization),2) as 'Utilization',
ROUND((dwh_performance.storage_node_hourly_performance_fact.utilizationmax),2) as 'PeakUtilization'

FROM dwh_performance.storage_node_hourly_performance_fact
JOIN dwh_performance.storage_node_dimension
ON dwh_performance.storage_node_dimension.tk=dwh_performance.storage_node_hourly_performance_fact.storagenodetk

GROUP BY dwh_performance.storage_node_dimension.id) nodeperf ON nodeperf.nodeid=volperf.volnodeid

JOIN

(
select
dwh_inventory.storage_node.id as disknodeid,
dwh_inventory.storage_pool.id as poolid,
dwh_inventory.storage_node.name as 'node',
dwh_inventory.storage_pool.name as 'pool',
dwh_inventory.storage_pool.dataAllocatedCapacityMB/1024 as CapacityGB,
dwh_inventory.storage_pool.dataUsedCapacityMB/1024 as UsedCapacityGB,
-- GROUP_CONCAT(DISTINCT dwh_inventory.disk.type) as 'DiskType',
dwh_inventory.disk.type as 'DiskType',
COUNT(DISTINCT dwh_inventory.disk.id) AS DiskCount,

	    CASE
	  WHEN dwh_inventory.disk.type = 'SSD' THEN 3000 
	  WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 200
	  WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 7200 THEN 85
	  WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 200
	  WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 170
	  WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 170
	  WHEN dwh_inventory.disk.type = 'SATA' THEN 75
	  	END AS DiskIOpSCapability,
        COUNT(DISTINCT dwh_inventory.disk.id) * 
			(CASE
				WHEN dwh_inventory.disk.type = 'SSD' THEN 3000
				WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 200
				WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 7200 THEN 85
				WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 200
				WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 170
				WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 170
				WHEN dwh_inventory.disk.type = 'SATA' THEN 75
				END)  AS MaxSupportedIOpS



FROM dwh_inventory.storage_node
JOIN dwh_inventory.storage_node_to_storage_pool
ON dwh_inventory.storage_node_to_storage_pool.storagenodeid=dwh_inventory.storage_node.id
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.storage_node_to_storage_pool.storagepoolid
JOIN dwh_inventory.storage_pool_to_disk
ON dwh_inventory.storage_pool_to_disk.storagepoolid=dwh_inventory.storage_pool.id
JOIN dwh_inventory.disk
ON dwh_inventory.disk.id=dwh_inventory.storage_pool_to_disk.diskid


GROUP by dwh_inventory.storage_node.id, dwh_inventory.storage_pool.id, dwh_inventory.disk.type  ) nodedisk ON nodedisk.disknodeid=volperf.volnodeid AND nodedisk.poolid=volperf.poolid


GROUP BY volperf.Node




















</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/><mdProjectedItem name="IO Density"/><mdProjectedItem name="Ranges"/><mdProjectedItem name="CPU Utilization"/><mdProjectedItem name="Peak CPU Utilization"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Disk Type"/><mdProjectedItem name="Total Capacity GB"/><mdProjectedItem name="Total Used GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name" label="Node Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL1].[Aggregate]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL1].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL1].[Max Total IOpS]</expression></dataItem><dataItem name="IO Density"><expression>[SQL1].[IO Density]</expression></dataItem><dataItem name="CPU Utilization" label="Node Utilization" aggregate="average"><expression>[SQL1].[CPU Utilization]</expression></dataItem><dataItem name="Peak CPU Utilization" label="Peak Node Utilization" aggregate="maximum"><expression>[SQL1].[Peak CPU Utilization]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL1].[Max Supported IOpS]</expression></dataItem><dataItem name="Total Capacity GB"><expression>[SQL1].[Total Capacity GB]</expression></dataItem><dataItem name="Total Used GB"><expression>[SQL1].[Total Used GB]</expression></dataItem><dataItem name="Current Workload %"><expression>[Max Total IOpS]/[Max Supported IOpS]</expression></dataItem><dataItem name="Ranges"><expression>[SQL1].[Ranges]</expression></dataItem><dataItem name="Capacity Utilization %"><expression>Total([Total Used GB] for [Aggregate])
/
Total([Total Capacity GB] for [Aggregate])</expression></dataItem><dataItem name="Disk Type"><expression>[SQL1].[Disk Type]</expression></dataItem><dataItem name="Status"><expression>CASE
WHEN [Peak CPU Utilization]&lt;50 AND [Current Workload %]&lt;.50 AND [Capacity Utilization %]&lt;.75 THEN 'OK'
WHEN [Peak CPU Utilization]&gt;=50 THEN 'WARNING - Head Room at Risk'
WHEN [Current Workload %]&gt;=.50 THEN 'WARNING - Heavy Workload Activity Approaching Maximum Capability'
WHEN [Capacity Utilization %]&gt;=.75 THEN 'WARNING - Capacity Utilization is Nearing Full'
END</expression></dataItem></selection>
		</query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 5"><styleCases><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Capacity Changes].[Raw Change (Hidden)] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#72B577"/></style><reportCondition>[Global Capacity Changes].[Raw Change (Hidden)] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 6"><styleCases><styleCase><style><CSS value="color:#72B577"/></style><reportCondition>[Global Capacity Changes].[Unconfigured Change (Hidden)] &gt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Capacity Changes].[Unconfigured Change (Hidden)] &lt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 7"><styleCases><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Capacity Changes].[Usable Change (Hidden)] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#72B577"/></style><reportCondition>[Global Capacity Changes].[Usable Change (Hidden)] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 8"><styleCases><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Capacity Changes].[Allocated Changes (Hidden)] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#72B577"/></style><reportCondition>[Global Capacity Changes].[Allocated Changes (Hidden)] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 9"><styleCases><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Cost Changes].[Usable Change (Hidden)] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#71B577"/></style><reportCondition>[Global Cost Changes].[Usable Change (Hidden)] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 10"><styleCases><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Cost Changes].[Used Change (Hidden)] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#71B577"/></style><reportCondition>[Global Cost Changes].[Used Change (Hidden)] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 11"><styleCases><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Cost Changes].[Allocated Changes (Hidden)] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#71B577"/></style><reportCondition>[Global Cost Changes].[Allocated Changes (Hidden)] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 12"><styleCases><styleCase><style><CSS value="color:#DC5645"/></style><reportCondition>[Global Cost Changes].[Free Change (Hidden)] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#71B577"/></style><reportCondition>[Global Cost Changes].[Free Change (Hidden)] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:gray"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#009966;font-weight:bold"/></style><reportCondition>[Head Room Query - Release 4].[Status]='OK'</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:maroon;font-weight:bold"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:maroon;font-weight:bold"/></style><reportCondition>[Head Room Query - Release 4].[Peak CPU Utilization]&gt;50</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 3"><styleCases><styleCase><style><CSS value="color:maroon;font-weight:bold"/></style><reportCondition>[Head Room Query - Release 4].[Current Workload %]&gt;.50</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 4"><styleCases><styleCase><style><CSS value="color:maroon;font-weight:bold"/></style><reportCondition>[Head Room Query - Release 4].[Capacity Utilization %]&gt;=.75</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles></report>